﻿<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>选择数据库表
    </title>
    <meta name="description" content="">
    <meta name="author" content="">

    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <!-- #CSS Links -->
    <!-- Basic Styles -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/font-awesome.css">

    <!-- SmartAdmin Styles : Caution! DO NOT change the order -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production-plugins.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-skins.css">

    <!-- SmartAdmin RTL Support -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-rtl.css">

    <!-- Demo purpose only: goes with demo.js, you can delete this css when designing your own WebApp -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/demo.css">

    <!-- #FAVICONS -->
    <link rel="shortcut icon" href="img/favicon/favicon.ico" type="image/x-icon">
    <link rel="icon" href="img/favicon/favicon.ico" type="image/x-icon">

    <!-- #GOOGLE FONT -->
    <link rel="stylesheet" href="css/open-sans.css" type="text/css">

    <!-- #APP SCREEN / ICONS -->
    <link rel="apple-touch-icon" href="img/splash/sptouch-icon-iphone.png">
    <link rel="apple-touch-icon" sizes="76x76" href="img/splash/touch-icon-ipad.png">
    <link rel="apple-touch-icon" sizes="120x120" href="img/splash/touch-icon-iphone-retina.png">
    <link rel="apple-touch-icon" sizes="152x152" href="img/splash/touch-icon-ipad-retina.png">

    <!-- iOS web-app metas : hides Safari UI Components and Changes Status Bar Appearance -->
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <!-- Startup image for web apps -->
    <link rel="apple-touch-startup-image" href="img/splash/ipad-landscape.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:landscape)">
    <link rel="apple-touch-startup-image" href="img/splash/ipad-portrait.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:portrait)">
    <link rel="apple-touch-startup-image" href="img/splash/iphone.png" media="screen and (max-device-width: 320px)">
    <link href="appcss/Common.css" rel="stylesheet" />

</head>
<body class="desktop-detected minified">

    <!-- #MAIN PANEL -->
    <div id="main" role="main">

        <!-- RIBBON -->
        <div id="ribbon">


            <span class="ribbon-button-alignment">
                <span class="btn btn-ribbon"><i class="fa fa-home"></i></span>
            </span>

            <!-- breadcrumb -->
            <ol class="breadcrumb">
                <li><a href="DataServiceManagement.html">数据服务管理</a></li>
                <li><a href="javascript:window.history.back();">数据源管理</a></li>
                <li><a href="javascript:window.history.back();">数据源选择对应数据表方式</a></li>
                <li><a href="javascript:window.history.back();">选择已有数据表</a></li>
                <li>设置数据表对应字段</li>
            </ol>

        </div>
        <!-- END RIBBON -->


        <!-- MAIN CONTENT -->
        <div id="content">
            <div class="row hidden">
                <div class="col-xs-12 col-sm-7 col-md-7 col-lg-4">
                    <h1 class="page-title txt-color-blueDark">
                        <i class="fa fa-edit fa-fw "></i>
                        主页
            <span>> 
				选择数据库表
            </span>
                    </h1>
                </div>

            </div>

            <!-- widget grid -->
            <section id="widget-grid" class="">

                <!-- row -->
                <div class="row">

                    <!-- NEW WIDGET START -->


                    <!-- NEW WIDGET START -->
                    <article class="col-sm-12 col-md-12 ">

                        <!-- Widget ID (each widget will need unique ID)-->
                        <div class="jarviswidget" id="wid-id-2" data-widget-colorbutton="false"
                            data-widget-editbutton="false">
                            <header>
                                <h2>选择数据库表</h2>

                            </header>

                            <!-- widget div-->
                            <div>

                                <!-- widget edit box -->
                                <div class="jarviswidget-editbox">
                                    <!-- This area used as dropdown edit box -->

                                </div>
                                <!-- end widget edit box -->

                                <!-- widget content -->
                                <div class="widget-body no-padding">

                                    <!-- Success states for elements -->

                                    <form action="" class="smart-form" id="Chose-Form">

                                        <header>填写相关信息</header>
                                        <fieldset>
                                            <section>
                                                <label class="label">数据服务</label>
                                                <label class="input">
                                                    <input type="text" disabled="disabled" value="" id="ServiceName">
                                                </label>
                                            </section>

                                            <section>
                                                <label class="label">数据源</label>
                                                <label class="input">
                                                    <input type="text" disabled="disabled" value="" id="SourceName" />
                                                </label>
                                            </section>
                                            <section>
                                                <label class="label">数据表</label>
                                                <label class="input">
                                                    <input type="text" disabled="disabled" value="" id="TableName">
                                                </label>
                                            </section>
                                            <section>
                                                <label class="label">
                                                    可追踪数据表
                                                    <input type="checkbox" disabled="disabled" value="" id="IsRawDt" name="IsRawDt"></label>

                                            </section>
                                        </fieldset>
                                        <fieldset>
                                            <section>
                                                <label class="label">
                                                    数据表
                                                </label>
                                                <table class="table table-bordered table-condensed table-hover smart-form " id="dataBaseColumn">
                                                    <thead>
                                                        <tr>
                                                            <th>数据列</th>
                                                            <th>数据库-列</th>
                                                            <th>类型</th>
                                                            <th>Length</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                    </tbody>
                                                </table>
                                            </section>
                                        </fieldset>
                                        <fieldset>
                                            <section>
                                                <label class="label">
                                                    数据标识
                                                </label>
                                                <table class="table table-bordered table-condensed table-hover smart-form  has-tickbox" style="width: 30%;" id="logocolumn">
                                                    <thead>
                                                        <tr>
                                                            <th></th>
                                                            <th>结果集字段</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                    </tbody>
                                                </table>
                                            </section>
                                        </fieldset>
                                        <footer>
                                            <input type="hidden" name="ServiceId" id="ServiceId">
                                            <input type="hidden" name="SourceId" id="SourceId">
                                            <input type="hidden" name="TableId" id="TableId">
                                            <input type="hidden" name="ColumnMapping" id="ColumnMapping">
                                            <input type="hidden" name="DataIdentity" id="DataIdentity">
                                            <input type="hidden" name="sys:sno" value="ETL" />
                                            <input type="hidden" name="sys:act" value="Mapping2ExistTable" />
                                            <button type="submit" class="btn btn-primary">提交</button>
                                            <button type="button" class="btn btn-primary" onclick="window.location.reload()">重新选择</button>
                                            <button type="button" class="btn" onclick="window.history.back()">取消</button>

                                        </footer>

                                    </form>
                                    <!--/ Success states for elements -->
                                </div>
                                <!-- end widget content -->
                            </div>
                            <!-- end widget div -->
                        </div>
                        <!-- end widget -->
                    </article>
                </div>

                <!-- end row -->

            </section>
        </div>
        <!-- END MAIN CONTENT -->
    </div>

    <!--================================================== -->

    <!-- PACE LOADER - turn this on if you want ajax loading to show (caution: uses lots of memory on iDevices)
<script data-pace-options='{ "restartOnRequestAfter": true }' src="js/plugin/pace/pace.min.js"></script>-->


    <!-- #PLUGINS -->
    <!-- Link to Google CDN's jQuery + jQueryUI; fall back to local -->


    <script src="js/libs/jquery-2.1.1.min.js"></script>
    <script src="js/libs/jquery-ui-1.10.3.min.js"></script>
    <!-- BOOTSTRAP JS -->
    <script src="js/bootstrap/bootstrap.min.js"></script>

    <!-- IMPORTANT: APP CONFIG -->
    <script src="js/app.config.js"></script>


    <!-- CUSTOM NOTIFICATION -->
    <script src="js/notification/SmartNotification.min.js"></script>

    <!-- JARVIS WIDGETS -->
    <script src="js/smartwidgets/jarvis.widget.min.js"></script>


    <!-- SPARKLINES -->
    <script src="js/plugin/sparkline/jquery.sparkline.min.js"></script>

    <!-- JQUERY MASKED INPUT -->
    <script src="js/plugin/masked-input/jquery.maskedinput.min.js"></script>


    <!-- JQUERY UI + Bootstrap Slider -->
    <script src="js/plugin/bootstrap-slider/bootstrap-slider.min.js"></script>


    <!--[if IE 8]>
<h1>Your browser is out of date, please update your browser by going to www.microsoft.com/download</h1>
<![endif]-->

    <!-- Demo purpose only
<script src="js/demo.min.js"></script>
-->
    <!-- MAIN APP JS FILE -->
    <script src="js/app.min.js"></script>
    <script src="appjs/Helper.js"></script>
    <script src="appjs/Common.js"></script>
    <script src="appjs/ChoseTableForDataSourceMappingTwo.js"></script>
    <script>
        var selectThisRow = function (a) {
            var $this = $(a);
            var obj = JSON.parse($this.attr("data"));
            var editobj = JSON.parse(edit.attr("data"));
            $this.parent().parent().remove();
            editobj.column = obj;
            edit.attr("data", JSON.stringify(editobj));
            edit.children().first().html("<a href='javascript:void(0);' onclick='ClearThisRow(this)'>" + obj.Name + "</a>");
            $("#logocolumn").append(AddLogoData(editobj));
            $("#add-parameter-modal").modal("hide");
        }
        var ClearThisRow = function (obj) {
            var $this = $(obj);
            var tempobj = JSON.parse($this.parent().parent().attr("data"));
            $("#alert-table").append(AddColumnData(tempobj.column));
            var columnid = tempobj.column.Id;
            tempobj.column = {};
            $this.parent().parent().attr("data", JSON.stringify(tempobj));
            $this.parent().html("<a href='javascript:void(0);' id=\"chose" + columnid + "\" onclick='selectDataFild(this)' data='" + tempobj.database.Id + "' >" + "选择列" + "</a>");
            $("#" + columnid).remove();
            //alert($this.parent().html());
            $("#chose" + columnid).click();
            //$("#add-parameter-modal").modal("show");
        }
    </script>

    <div aria-hidden="true" aria-labelledby="remoteModalLabel" role="dialog" tabindex="-1" id="add-parameter-modal"
        class="modal fade" style="display: none;">
        <div class="modal-dialog">
            <div class="modal-content" id="add-parameter-modal-container">
                <div class="modal-header">
                    <button aria-hidden="true" data-dismiss="modal" class="close" type="button">
                        ×
                    </button>
                    <h4 class="modal-title">选择</h4>
                </div>
                <div class="modal-body no-padding">

                    <form class="smart-form" id="add-parameter-form" method="POST">
                        <fieldset>
                            <section>
                                <table class="table table-bordered  table-condensed table-hover smart-form " id="alert-table">
                                    <thead>
                                        <tr>
                                            <th>结果集字段</th>
                                            <th>类型</th>
                                            <th>操作</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                            </section>
                        </fieldset>

                        <footer>
                        </footer>

                    </form>
                </div>
            </div>
        </div>
    </div>

</body>
</html>

